use gsi_lab1
go

--ponto 0
select i,k from t where  i between 100 and 200
select I,K from t where k = 200

create index i1 on t(i,k)
--ponto 1
select i,k from t where  i between 100 and 200

select i,j from t where  i between 100 and 200

select I,K from t where k = 200



drop index i1 on t

create index i1 on t(i)include(k)
--ponto 3
select i,k from t where  i between 100 and 200

select i,j from t where  i between 100 and 200

select I,K from t where k = 200